Page Control Search – Dynamics 365 BC Table Reference

SELECT p.ID ,p.Name ,pc.ControlName ,post.post_name FROM azrcrv_PageControls AS pc INNER JOIN azrcrv_Pages AS p ON p.ID = pc.PageNo INNER JOIN bct_posts AS post ON post.post_title = p.Name WHERE pc.ControlName = 'Lot No.' ORDER BY p.ID ,pc.ControlName

Dynamics 365 BC Table ReferencePage Control Search

Pages with controls equal to LOT NO.

Seq No	Page Number	Page Name	Control Name
1	38	Item Ledger Entries	Lot No.
2	40	Item Journal	Lot No.
3	92	Job Ledger Entries	Lot No.
4	93	Job Ledger Entries Preview	Lot No.
5	167	Item Ledger Entries Preview	Lot No.
6	497	Reservation Entries	Lot No.
7	504	Available – Item Ledg. Entries	Lot No.
8	521	Application Worksheet	Lot No.
9	522	View Applied Entries	Lot No.
10	1007	Job Planning Lines	Lot No.
11	5771	Whse. Put-away Subform	Lot No.
12	5780	Whse. Pick Subform	Lot No.
13	5796	Registered Put-away Subform	Lot No.
14	5799	Registered Pick Subform	Lot No.
15	5881	Phys. Invt. Recording Subform	Lot No.
16	5882	Phys. Invt. Recording Lines	Lot No.
17	5889	Posted Phys. Invt. Rec. Subf.	Lot No.
18	5890	Posted Phys. Invt. Rec. Lines	Lot No.
19	5893	Phys. Invt. Item Track. List	Lot No.
20	5894	Posted Phys. Invt. Tracking	Lot No.
21	5895	Exp. Phys. Invt. Tracking	Lot No.
22	5895	Exp. Phys. Invt. Tracking	Lot No.
23	5896	Posted Exp. Phys. Invt. Track	Lot No.
24	6500	Item Tracking Summary	Lot No.
25	6501	Item Tracking Entries	Lot No.
26	6503	Avail. – Item Tracking Lines	Lot No.
27	6505	Lot No. Information Card	Lot No.
28	6507	Item Tracking List	Lot No.
29	6508	Lot No. Information List	Lot No.
30	6510	Item Tracking Lines	Lot No.
31	6511	Posted Item Tracking Lines	Lot No.
32	6520	Item Tracing	Lot No.
33	6550	Whse. Item Tracking Lines	Lot No.
34	7316	Warehouse Movement Subform	Lot No.
35	7318	Warehouse Entries	Lot No.
36	7326	Whse. Phys. Invt. Journal	Lot No.
37	7350	Registered Movement Subform	Lot No.
38	7376	Invt. Put-away Subform	Lot No.
39	7378	Invt. Pick Subform	Lot No.
40	7383	Invt. Movement Subform	Lot No.
41	7385	Reg. Invt. Movement Subform	Lot No.
42	7391	Posted Invt. Put-away Subform	Lot No.
43	7393	Posted Invt. Pick Subform	Lot No.
44	7396	Posted Invt. Put-away Lines	Lot No.
45	7397	Posted Invt. Pick Lines	Lot No.
46	9126	Lot Numbers by Bin FactBox	Lot No.

Dynamics 365 BC Table ReferencePage Control Search